const Koa = require('koa')
const app = new Koa()
const views = require('koa-views')
const json = require('koa-json')
const onerror = require('koa-onerror')
const bodyparser = require('koa-bodyparser')
const logger = require('koa-logger')
// 数据库配置0 
const dbConfig = require('./bin/dbConfig')
const rootConfig = require('./bin/config')
const mysql = require('mysql')
const less = require('koa-less')

const index = require('./routes/index')
const users = require('./routes/users')
const workLogs = require('./routes/work-log')

const db = mysql.createConnection(dbConfig)

app.use(less('./public'));

db.connect(err => {
  if (err) { console.log('数据库连接失败') }
  console.log('数据库连接成功')
})

// error handler
onerror(app)

app.context.db = db
app.context.rootConfig = rootConfig
app.context.dbQuery = (sql, post) => {
  return new Promise((resolve, reject) => {
    db.query(sql,post, (error, results, fields) => {
      if (error) {
        reject(error)
      } else {
        resolve({
          results,
          fields
        })
      }
    })
  })
}
// middlewares
app.use(bodyparser({
  enableTypes:['json', 'form', 'text']
}))
app.use(json())
app.use(logger())
app.use(require('koa-static')(__dirname + '/public'))

app.use(views(__dirname + '/views', {
  extension: 'ejs'
}))

// logger
app.use(async (ctx, next) => {
  const start = new Date()
  await next()
  const ms = new Date() - start
  console.log(`${ctx.method} ${ctx.url} - ${ms}ms`)
})

// routes
app.use(index.routes(), index.allowedMethods())
app.use(users.routes(), users.allowedMethods())
app.use(workLogs.routes(), workLogs.allowedMethods())

// error-handling
app.on('error', (err, ctx) => {
  console.error('server error', err, ctx)
});

module.exports = app
